package labox.innovation.gameserver.model;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.List;
import java.util.Map;

import org.slf4j.Logger;
import org.slf4j.LoggerFactory;

import javolution.util.FastList;
import javolution.util.FastMap;

import labox.innovation.config.Config;
import labox.innovation.db.core.L2DatabaseFactory;
import labox.innovation.gameserver.communitybbs.BB.Forum;
import labox.innovation.gameserver.communitybbs.Manager.ForumsBBSManager;
import labox.innovation.gameserver.datatables.ClanTable;
import labox.innovation.gameserver.datatables.SkillTable;
//import labox.innovation.gameserver.instancemanager.CastleManager;
//import labox.innovation.gameserver.instancemanager.FortManager;
//import labox.innovation.gameserver.instancemanager.SiegeManager;
import labox.innovation.gameserver.model.actor.L2Character;
import labox.innovation.gameserver.model.actor.instance.FuzePcInstance;
import labox.innovation.gameserver.model.itemcontainer.ItemContainer;
import labox.innovation.gameserver.network.SystemMessageId;
import labox.innovation.gameserver.network.clientpackets.Say2;
import labox.innovation.gameserver.network.serverpackets.CreatureSay;
//import labox.innovation.gameserver.network.serverpackets.ExBrExtraUserInfo;
import labox.innovation.gameserver.network.serverpackets.ItemList;
import labox.innovation.gameserver.network.serverpackets.L2GameServerPacket;
//import labox.innovation.gameserver.network.serverpackets.PledgeReceiveSubPledgeCreated;
//import labox.innovation.gameserver.network.serverpackets.PledgeShowInfoUpdate;
//import labox.innovation.gameserver.network.serverpackets.PledgeShowMemberListAll;
//import labox.innovation.gameserver.network.serverpackets.PledgeShowMemberListDeleteAll;
//import labox.innovation.gameserver.network.serverpackets.PledgeShowMemberListUpdate;
//import labox.innovation.gameserver.network.serverpackets.PledgeSkillListAdd;
//import labox.innovation.gameserver.network.serverpackets.SkillCoolTime;
import labox.innovation.gameserver.network.serverpackets.StatusUpdate;
import labox.innovation.gameserver.network.serverpackets.SystemMessage;
import labox.innovation.gameserver.network.serverpackets.UserInfo;
import labox.innovation.util.Util;

/**
 * 帮会对象类，处理一个帮会实例的所有逻辑
 *
 * @version $Revision: 1.7.2.4.2.7 $ $Date: 2005/04/06 16:13:41 $
 */
public class L2Clan {
	private static final Logger _log = LoggerFactory.getLogger(L2Clan.class.getName());

	private String _name;

	private long _clanId;

	private L2ClanMember _leader;

	private Map<Long, L2ClanMember> _members = new FastMap<Long, L2ClanMember>();

	private String _allyName;

	private long _allyId;

	private int _level;

	private int _hasCastle;

	private int _hasFort;

	private int _hasHideout;

	private boolean _hasCrest;

	private int _hiredGuards;

	private long _crestId;

	private int _crestLargeId;

	private int _allyCrestId;

	private int _auctionBiddedAt = 0;

	private long _allyPenaltyExpiryTime;

	private int _allyPenaltyType;

	private long _charPenaltyExpiryTime;

	private long _dissolvingExpiryTime;

	// Ally Penalty Types
	/** Clan leaved ally */
	public static final int PENALTY_TYPE_CLAN_LEAVED = 1;

	/** Clan was dismissed from ally */
	public static final int PENALTY_TYPE_CLAN_DISMISSED = 2;

	/** Leader clan dismiss clan from ally */
	public static final int PENALTY_TYPE_DISMISS_CLAN = 3;

	/** Leader clan dissolve ally */
	public static final int PENALTY_TYPE_DISSOLVE_ALLY = 4;

//	private ItemContainer _warehouse = new ClanWarehouse(this);

	private List<Long> _atWarWith = new FastList<Long>();

	private List<Long> _atWarAttackers = new FastList<Long>();

	private boolean _hasCrestLarge;

	private Forum _forum;

	private List<L2Skill> _skillList = new FastList<L2Skill>();

	//  Clan Privileges
	/** No privilege to manage any clan activity */
	public static final int CP_NOTHING = 0;

	/** Privilege to join clan */
	public static final int CP_CL_JOIN_CLAN = 2;

	/** Privilege to give a title */
	public static final int CP_CL_GIVE_TITLE = 4;

	/** Privilege to view warehouse content */
	public static final int CP_CL_VIEW_WAREHOUSE = 8;

	/** Privilege to manage clan ranks */
	public static final int CP_CL_MANAGE_RANKS = 16;

	public static final int CP_CL_PLEDGE_WAR = 32;

	public static final int CP_CL_DISMISS = 64;

	/** Privilege to register clan crest */
	public static final int CP_CL_REGISTER_CREST = 128;

	public static final int CP_CL_APPRENTICE = 256;

	public static final int CP_CL_TROOPS_FAME = 512;

	public static final int CP_CL_SUMMON_AIRSHIP = 1024;

	/** Privilege to open a door */
	public static final int CP_CH_OPEN_DOOR = 2048;

	public static final int CP_CH_OTHER_RIGHTS = 4096;

	public static final int CP_CH_AUCTION = 8192;

	public static final int CP_CH_DISMISS = 16384;

	public static final int CP_CH_SET_FUNCTIONS = 32768;

	public static final int CP_CS_OPEN_DOOR = 65536;

	public static final int CP_CS_MANOR_ADMIN = 131072;

	public static final int CP_CS_MANAGE_SIEGE = 262144;

	public static final int CP_CS_USE_FUNCTIONS = 524288;

	public static final int CP_CS_DISMISS = 1048576;

	public static final int CP_CS_TAXES = 2097152;

	public static final int CP_CS_MERCENARIES = 4194304;

	public static final int CP_CS_SET_FUNCTIONS = 8388608;

	/** Privilege to manage all clan activity */
	public static final int CP_ALL = 16777214;

	// Sub-unit types
	/** Clan subunit type of Academy */
	public static final int SUBUNIT_ACADEMY = -1;

	/** Clan subunit type of Royal Guard A */
	public static final int SUBUNIT_ROYAL1 = 100;

	/** Clan subunit type of Royal Guard B */
	public static final int SUBUNIT_ROYAL2 = 200;

	/** Clan subunit type of Order of Knights A-1 */
	public static final int SUBUNIT_KNIGHT1 = 1001;

	/** Clan subunit type of Order of Knights A-2 */
	public static final int SUBUNIT_KNIGHT2 = 1002;

	/** Clan subunit type of Order of Knights B-1 */
	public static final int SUBUNIT_KNIGHT3 = 2001;

	/** Clan subunit type of Order of Knights B-2 */
	public static final int SUBUNIT_KNIGHT4 = 2002;

	/** FastMap(Integer, L2Skill) containing all skills of the L2Clan */
	protected final Map<Integer, L2Skill> _skills = new FastMap<Integer, L2Skill>();

	protected final Map<Integer, RankPrivs> _privs = new FastMap<Integer, RankPrivs>();

	protected final Map<Long, SubPledge> _subPledges = new FastMap<Long, SubPledge>();

	private int _reputationScore;

	private int _rank;

	private String _notice;

	private boolean _noticeEnabled = false;

	private static final int MAX_NOTICE_LENGTH = 8192;

	/**
	 * Called if a clan is referenced only by id.
	 * In this case all other data needs to be fetched from db
	 *
	 * @param clanId A valid clan Id to create and restore
	 */
	public L2Clan(long clanId) {
		_clanId = clanId;
		initializePrivs();
		restore();
//		getWarehouse().restore();
	}

	/**
	 * Called only if a new clan is created
	 *
	 * @param clanId  A valid clan Id to create
	 * @param clanName  A valid clan name
	 */
	public L2Clan(long clanId, String clanName) {
		_clanId = clanId;
		_name = clanName;
		initializePrivs();
	}

	/**
	 * @return Returns the clanId.
	 */
	public long getClanId() {
		return _clanId;
	}

	/**
	 * @param clanId The clanId to set.
	 */
	public void setClanId(long clanId) {
		_clanId = clanId;
	}

	/**
	 * @return Returns the leaderId.
	 */
	public long getLeaderId() {
		return (_leader != null ? _leader.getObjectId() : 0);
	}

	/**
	 * @return L2ClanMember of clan leader.
	 */
	public L2ClanMember getLeader() {
		return _leader;
	}

	/**
	 * @param leaderId The leaderId to set.
	 */
	public void setLeader(L2ClanMember leader) {
		_leader = leader;
		_members.put(leader.getObjectId(), leader);
	}

	public void setNewLeader(L2ClanMember member) {
		if (!getLeader().isOnline()) {
			return;
		}
		if (member == null) {
			return;
		}
		if (!member.isOnline()) {
			return;
		}

		FuzePcInstance exLeader = getLeader().getPlayerInstance();
//		SiegeManager.getInstance().removeSiegeSkills(exLeader);
		exLeader.setClan(this);
		exLeader.setClanPrivileges(L2Clan.CP_NOTHING);
		exLeader.broadcastUserInfo();

		setLeader(member);
		updateClanInDB();

//		exLeader.setPledgeClass(exLeader.getClan().getClanMember(exLeader.getObjectId()).calculatePledgeClass(exLeader));
		exLeader.broadcastUserInfo();
		exLeader.checkItemRestriction();
		FuzePcInstance newLeader = member.getPlayerInstance();
		newLeader.setClan(this);
//		newLeader.setPledgeClass(member.calculatePledgeClass(newLeader));
		newLeader.setClanPrivileges(L2Clan.CP_ALL);
////		if (getLevel() >= SiegeManager.getInstance().getSiegeClanMinLevel()) {
////			SiegeManager.getInstance().addSiegeSkills(newLeader);
//
//			// Transferring siege skills TimeStamps from old leader to new leader to prevent unlimited headquarters
//			if (!exLeader.getReuseTimeStamp().isEmpty()) {
//				for (L2Skill sk : SkillTable.getInstance().getSiegeSkills(newLeader.isNoble())) {
//					if (exLeader.getReuseTimeStamp().containsKey(sk.getId()))
//						newLeader.addTimeStamp(exLeader.getReuseTimeStamp().get(sk.getId()));
//				}
//				newLeader.sendPacket(new SkillCoolTime(newLeader));
//			}
//		}
//		newLeader.broadcastUserInfo();
//
//		broadcastClanStatus();

//		SystemMessage sm = new SystemMessage(SystemMessageId.CLAN_LEADER_PRIVILEGES_HAVE_BEEN_TRANSFERRED_TO_C1);
//		sm.addString(newLeader.getName());
//		broadcastToOnlineMembers(sm);
//		sm = null;
	}

	/**
	 * @return Returns the leaderName.
	 */
	public String getLeaderName() {
//		return _members.get(Integer.valueOf(_leader.getObjectId())).getName();
		return null;
	}

	/**
	 * @return Returns the name.
	 */
	public String getName() {
		return _name;
	}

	/**
	 * @param name The name to set.
	 */
	public void setName(String name) {
		_name = name;
	}

	private void addClanMember(L2ClanMember member) {
		_members.put(member.getObjectId(), member);
	}

	public void addClanMember(FuzePcInstance player) {
		// Using a different constructor, to make it easier to read
		// L2ClanMember(L2Clan, L2PcInstance)
		// L2ClanMember member = new L2ClanMember(this,player.getName(), player.getLevel(), player.getClassId().getId(), player.getObjectId(), player.getPledgeType(), player.getPowerGrade(), player.getTitle(), player.getAppearance().getSex(), player.getRace().ordinal());
		L2ClanMember member = new L2ClanMember(this, player);
		// store in memory
		//
//		addClanMember(member);
//		member.setPlayerInstance(player);
//		player.setClan(this);
//		player.setPledgeClass(member.calculatePledgeClass(player));
//		player.sendPacket(new PledgeShowMemberListUpdate(player));
//		player.sendPacket(new UserInfo(player));
//		player.sendPacket(new ExBrExtraUserInfo(player));
	}

	public void updateClanMember(FuzePcInstance player) {
		L2ClanMember member = new L2ClanMember(player);
		if (player.isClanLeader())
			setLeader(member);

		addClanMember(member);
	}

	public L2ClanMember getClanMember(String name) {
		for (L2ClanMember temp : _members.values()) {
			if (temp.getName().equals(name))
				return temp;
		}
		return null;
	}

	public L2ClanMember getClanMember(long objectID) {
		return _members.get(objectID);
	}

	public void removeClanMember(long objectId, long clanJoinExpiryTime) {
		L2ClanMember exMember = _members.remove(objectId);
		if (exMember == null) {
			_log.warn("Member Object ID: " + objectId + " not found in clan while trying to remove");
			return;
		}
		int leadssubpledge = getLeaderSubPledge(objectId);
		if (leadssubpledge != 0) {
			// Sub-unit leader withdraws, position becomes vacant and leader
			// should appoint new via NPC
			getSubPledge(leadssubpledge).setLeaderId(0);
			updateSubPledgeInDB(leadssubpledge);
		}

		if (exMember.getApprentice() != 0) {
			L2ClanMember apprentice = getClanMember(exMember.getApprentice());
			if (apprentice != null) {
				if (apprentice.getPlayerInstance() != null)
					apprentice.getPlayerInstance().setSponsor(0);
				else
					apprentice.initApprenticeAndSponsor(0, 0);

				apprentice.saveApprenticeAndSponsor(0, 0);
			}
		}
		if (exMember.getSponsor() != 0) {
			L2ClanMember sponsor = getClanMember(exMember.getSponsor());
			if (sponsor != null) {
				if (sponsor.getPlayerInstance() != null)
					sponsor.getPlayerInstance().setApprentice(0);
				else
					sponsor.initApprenticeAndSponsor(0, 0);

				sponsor.saveApprenticeAndSponsor(0, 0);
			}
		}
		exMember.saveApprenticeAndSponsor(0, 0);
//		if (Config.REMOVE_CASTLE_CIRCLETS) {
//			CastleManager.getInstance().removeCirclet(exMember, getHasCastle());
//		}
//		if (exMember.isOnline()) {
//			FuzePcInstance player = exMember.getPlayerInstance();
//			player.setTitle("");
//			player.setApprentice(0);
//			player.setSponsor(0);
//
//			if (player.isClanLeader()) {
//				SiegeManager.getInstance().removeSiegeSkills(player);
//				player.setClanCreateExpiryTime(System.currentTimeMillis() + Config.ALT_CLAN_CREATE_DAYS * 86400000L); //24*60*60*1000 = 86400000
//			}
//			// remove Clanskills from Player
//			for (L2Skill skill : player.getClan().getAllSkills())
//				player.removeSkill(skill, false);
//			// remove Residential skills
//			if (player.getClan().getHasCastle() > 0)
//				CastleManager.getInstance().getCastleByOwner(player.getClan()).removeResidentialSkills(player);
//			if (player.getClan().getHasFort() > 0)
//				FortManager.getInstance().getFortByOwner(player.getClan()).removeResidentialSkills(player);
//			player.sendSkillList();
//
//			player.setClan(null);
//
//			// players leaving from clan academy have no penalty
//			if (exMember.getPledgeType() != -1)
//				player.setClanJoinExpiryTime(clanJoinExpiryTime);
//
//			player.setPledgeClass(exMember.calculatePledgeClass(player));
//			player.broadcastUserInfo();
//			// disable clan tab
//			player.sendPacket(new PledgeShowMemberListDeleteAll());
//		} else {
//			removeMemberInDatabase(exMember, clanJoinExpiryTime, getLeaderId() == objectId ? System.currentTimeMillis() + Config.ALT_CLAN_CREATE_DAYS * 86400000L : 0);
//		}
	}

	public L2ClanMember[] getMembers() {
		return _members.values().toArray(new L2ClanMember[_members.size()]);
	}

	public int getMembersCount() {
		return _members.size();
	}

	public int getSubPledgeMembersCount(int subpl) {
		int result = 0;
		for (L2ClanMember temp : _members.values()) {
			if (temp.getPledgeType() == subpl)
				result++;
		}
		return result;
	}

	public int getMaxNrOfMembers(int pledgetype) {
		int limit = 0;

		switch (pledgetype) {
		case 0:
			switch (getLevel()) {
			case 4:
				limit = 40;
				break;
			case 3:
				limit = 30;
				break;
			case 2:
				limit = 20;
				break;
			case 1:
				limit = 15;
				break;
			case 0:
				limit = 10;
				break;
			default:
				limit = 40;
				break;
			}
			break;
		case -1:
		case 100:
		case 200:
			limit = 20;
			break;
		case 1001:
		case 1002:
		case 2001:
		case 2002:
			switch (getLevel()) {
			case 9:
			case 10:
				limit = 25;
				break;
			default:
				limit = 10;
				break;
			}
			break;
		default:
			break;
		}

		return limit;
	}

	public FuzePcInstance[] getOnlineMembers(int exclude) {
		List<FuzePcInstance> result = new FastList<FuzePcInstance>();
		for (L2ClanMember temp : _members.values()) {
			try {
				if (temp.isOnline() && !(temp.getObjectId() == exclude))
					result.add(temp.getPlayerInstance());
			} catch (NullPointerException e) {
			}
		}

		return result.toArray(new FuzePcInstance[result.size()]);

	}

	/**
	 * 同盟的ID
	 * @return
	 */
	public int getAllyId() {
//		return _allyId;
		return -1;
	}

	/**
	 * 同盟的名称
	 * @return
	 */
	public String getAllyName() {
		return _allyName;
	}

	public void setAllyCrestId(int allyCrestId) {
		_allyCrestId = allyCrestId;
	}

	/**
	 * @return
	 */
	public int getAllyCrestId() {
		return _allyCrestId;
	}

	/**
	 * @return
	 */
	public int getLevel() {
		return _level;
	}

	/**
	 * @return
	 */
	public int getHasCastle() {
		return _hasCastle;
	}

	/**
	 * @return
	 */
	public int getHasFort() {
		return _hasFort;
	}

	/**
	 * @return
	 */
	public int getHasHideout() {
		return _hasHideout;
	}

	/**
	 * @param crestId The id of pledge crest.
	 */
	public void setCrestId(long crestId) {
		_crestId = crestId;
	}

	/**
	 * @return Returns the clanCrestId.
	 */
	public long getCrestId() {
		return _crestId;
	}

	/**
	 * @param crestLargeId The id of pledge LargeCrest.
	 */
	public void setCrestLargeId(int crestLargeId) {
		_crestLargeId = crestLargeId;
	}

	/**
	 * @return Returns the clan CrestLargeId
	 */
	public int getCrestLargeId() {
		return _crestLargeId;
	}

	/**
	 * @param allyId The allyId to set.
	 */
	public void setAllyId(long allyId) {
		_allyId = allyId;
	}

	/**
	 * @param allyName The allyName to set.
	 */
	public void setAllyName(String allyName) {
		_allyName = allyName;
	}

	/**
	 * @param hasCastle The hasCastle to set.
	 */
	public void setHasCastle(int hasCastle) {
		_hasCastle = hasCastle;
	}

	/**
	 * @param hasFort The hasFort to set.
	 */
	public void setHasFort(int hasFort) {
		_hasFort = hasFort;
	}

	/**
	 * @param hasHideout The hasHideout to set.
	 */
	public void setHasHideout(int hasHideout) {
		_hasHideout = hasHideout;
	}

	/**
	 * @param level The level to set.
	 */
	public void setLevel(int level) {
		_level = level;
		if (_level >= 2 && _forum == null && Config.COMMUNITY_TYPE > 0) {

			Forum forum = ForumsBBSManager.getInstance().getForumByName("ClanRoot");

			if (forum != null) {
//				_forum = forum.getChildByName(_name);

				if (_forum == null) {
					_forum = ForumsBBSManager.getInstance().createNewForum(_name, ForumsBBSManager.getInstance().getForumByName("ClanRoot"), Forum.CLAN, Forum.CLANMEMBERONLY, getClanId());
				}
			}
		}
	}

	/**
	 * @param player name
	 * @return
	 */
	public boolean isMember(long id) {
		return (id == 0 ? false : _members.containsKey(id));
	}

	public void updateClanInDB() {
		Connection con = null;
		PreparedStatement statement = null;
		try {
			con = L2DatabaseFactory.getInstance().getConnection();
			statement = con.prepareStatement("UPDATE clan_data SET leader_id=?,ally_id=?,ally_name=?,reputation_score=?,ally_penalty_expiry_time=?,ally_penalty_type=?,char_penalty_expiry_time=?,dissolving_expiry_time=? WHERE clan_id=?");
//			statement.setInt(1, getLeaderId());
			statement.setInt(2, getAllyId());
			statement.setString(3, getAllyName());
			statement.setInt(4, getReputationScore());
			statement.setLong(5, getAllyPenaltyExpiryTime());
			statement.setInt(6, getAllyPenaltyType());
			statement.setLong(7, getCharPenaltyExpiryTime());
			statement.setLong(8, getDissolvingExpiryTime());
			statement.setLong(9, getClanId());
			statement.execute();
//			if (Config.DEBUG)
////				_log.fine("New clan leader saved in db: " + getClanId());
		} catch (Exception e) {
//			_log.log(Level.SEVERE, "Error saving new clan leader.", e);
		} finally {
			if (statement != null)
				try {
					statement.close();
				} catch (Exception e) {
					e.printStackTrace();
				}
			if (con != null)
				try {
					con.close();
				} catch (Exception e) {
					e.printStackTrace();
				}
		}
	}

	public void store() {
		Connection con = null;
		try {
			con = L2DatabaseFactory.getInstance().getConnection();
			PreparedStatement statement = con.prepareStatement("INSERT INTO clan_data (clan_id,clan_name,clan_level,hasCastle,ally_id,ally_name,leader_id,crest_id,crest_large_id,ally_crest_id) values (?,?,?,?,?,?,?,?,?,?)");
			statement.setLong(1, getClanId());
			statement.setString(2, getName());
			statement.setInt(3, getLevel());
			statement.setInt(4, getHasCastle());
			statement.setInt(5, getAllyId());
			statement.setString(6, getAllyName());
//			statement.setInt(7, getLeaderId());
			statement.setLong(8, getCrestId());
			statement.setInt(9, getCrestLargeId());
			statement.setInt(10, getAllyCrestId());
			statement.execute();
			statement.close();

			if (Config.DEBUG)
				_log.info("New clan saved in db: " + getClanId());
		} catch (Exception e) {
			_log.error("Error saving new clan.", e);
		} finally {
			try {
				con.close();
			} catch (Exception e) {
			}
		}
	}

	private void removeMemberInDatabase(L2ClanMember member, long clanJoinExpiryTime, long clanCreateExpiryTime) {
		Connection con = null;
		try {
			con = L2DatabaseFactory.getInstance().getConnection();
			PreparedStatement statement = con.prepareStatement("UPDATE characters SET clanid=0, title=?, clan_join_expiry_time=?, clan_create_expiry_time=?, clan_privs=0, wantspeace=0, subpledge=0, lvl_joined_academy=0, apprentice=0, sponsor=0 WHERE charId=?");
			statement.setString(1, "");
			statement.setLong(2, clanJoinExpiryTime);
			statement.setLong(3, clanCreateExpiryTime);
//			statement.setInt(4, member.getObjectId());
			statement.execute();
			statement.close();
			if (Config.DEBUG)
				_log.info("clan member removed in db: " + getClanId());

			statement = con.prepareStatement("UPDATE characters SET apprentice=0 WHERE apprentice=?");
//			statement.setInt(1, member.getObjectId());
			statement.execute();
			statement.close();

			statement = con.prepareStatement("UPDATE characters SET sponsor=0 WHERE sponsor=?");
//			statement.setInt(1, member.getObjectId());
			statement.execute();
			statement.close();
		} catch (Exception e) {
			_log.error("Error removing clan member.", e);
		} finally {
			try {
				con.close();
			} catch (Exception e) {
			}
		}
	}

	@SuppressWarnings("unused")
	private void updateWarsInDB() {
		Connection con = null;
		try {
			con = L2DatabaseFactory.getInstance().getConnection();
			PreparedStatement statement;
			statement = con.prepareStatement("UPDATE clan_wars SET wantspeace1=? WHERE clan1=?");
			statement.setInt(1, 0);
			statement.setInt(2, 0);

			// TODO: deprecated? no execute? :o

			statement.close();
		} catch (Exception e) {
			_log.error("Error updating clan wars data.", e);
		} finally {
			try {
				con.close();
			} catch (Exception e) {
			}
		}
	}

	private void restore() {
		//restorewars();
		Connection con = null;
		try {
			L2ClanMember member;

			con = L2DatabaseFactory.getInstance().getConnection();
			PreparedStatement statement = con.prepareStatement("SELECT clan_name,clan_level,hasCastle,ally_id,ally_name,leader_id,crest_id,crest_large_id,ally_crest_id,reputation_score,auction_bid_at,ally_penalty_expiry_time,ally_penalty_type,char_penalty_expiry_time,dissolving_expiry_time FROM clan_data where clan_id=?");
			statement.setLong(1, getClanId());
			ResultSet clanData = statement.executeQuery();

			if (clanData.next()) {
				setName(clanData.getString("clan_name"));
				setLevel(clanData.getInt("clan_level"));
				setHasCastle(clanData.getInt("hasCastle"));
				setAllyId(clanData.getInt("ally_id"));
				setAllyName(clanData.getString("ally_name"));
				setAllyPenaltyExpiryTime(clanData.getLong("ally_penalty_expiry_time"), clanData.getInt("ally_penalty_type"));
				if (getAllyPenaltyExpiryTime() < System.currentTimeMillis()) {
					setAllyPenaltyExpiryTime(0, 0);
				}
				setCharPenaltyExpiryTime(clanData.getLong("char_penalty_expiry_time"));
				if (getCharPenaltyExpiryTime() + Config.ALT_CLAN_JOIN_DAYS * 86400000L < System.currentTimeMillis()) //24*60*60*1000 = 86400000
				{
					setCharPenaltyExpiryTime(0);
				}
				setDissolvingExpiryTime(clanData.getLong("dissolving_expiry_time"));

				setCrestId(clanData.getInt("crest_id"));
				if (getCrestId() != 0) {
					setHasCrest(true);
				}

				setCrestLargeId(clanData.getInt("crest_large_id"));
				if (getCrestLargeId() != 0) {
					setHasCrestLarge(true);
				}

				setAllyCrestId(clanData.getInt("ally_crest_id"));
				setReputationScore(clanData.getInt("reputation_score"), false);
				setAuctionBiddedAt(clanData.getInt("auction_bid_at"), false);

				int leaderId = (clanData.getInt("leader_id"));

				PreparedStatement statement2 = con.prepareStatement("SELECT char_name,level,classid,charId,title,power_grade,subpledge,apprentice,sponsor,sex,race FROM characters WHERE clanid=?");
				statement2.setLong(1, getClanId());
				ResultSet clanMembers = statement2.executeQuery();

				while (clanMembers.next()) {
					member = new L2ClanMember(this, clanMembers.getString("char_name"), clanMembers.getInt("level"), clanMembers.getInt("classid"), clanMembers.getInt("charId"), clanMembers.getInt("subpledge"), clanMembers.getInt("power_grade"), clanMembers.getString("title"), (clanMembers.getInt("sex") != 0), clanMembers.getInt("race"));
					if (member.getObjectId() == leaderId)
						setLeader(member);
					else
						addClanMember(member);
					member.initApprenticeAndSponsor(clanMembers.getInt("apprentice"), clanMembers.getInt("sponsor"));
				}
				clanMembers.close();
				statement2.close();
			}

			clanData.close();
			statement.close();

			if (Config.DEBUG && getName() != null)
				_log.info("Restored clan data for \"" + getName() + "\" from database.");
			restoreSubPledges();
			restoreRankPrivs();
			restoreSkills();
			restoreNotice();
		} catch (Exception e) {
			_log.error("Error restoring clan data.", e);
		} finally {
			try {
				con.close();
			} catch (Exception e) {
			}
		}
	}

	private void restoreNotice() {
		Connection con = null;
		try {
			con = L2DatabaseFactory.getInstance().getConnection();
			PreparedStatement statement = con.prepareStatement("SELECT enabled,notice FROM clan_notices WHERE clan_id=?");
			statement.setLong(1, getClanId());
			ResultSet noticeData = statement.executeQuery();

			while (noticeData.next()) {
				_noticeEnabled = noticeData.getBoolean("enabled");
				_notice = noticeData.getString("notice");
			}

			noticeData.close();
			statement.close();
		} catch (Exception e) {
			_log.error("Error restoring clan notice.", e);
		} finally {
			try {
				con.close();
			} catch (Exception e) {
			}
		}

	}

	private void storeNotice(String notice, boolean enabled) {
		if (notice == null)
			notice = "";

		if (notice.length() > MAX_NOTICE_LENGTH)
			notice = notice.substring(0, MAX_NOTICE_LENGTH - 1);

		Connection con = null;
		try {
			con = L2DatabaseFactory.getInstance().getConnection();
			PreparedStatement statement = con.prepareStatement("INSERT INTO clan_notices (clan_id,notice,enabled) values (?,?,?) ON DUPLICATE KEY UPDATE notice=?,enabled=?");
			statement.setLong(1, getClanId());
			statement.setString(2, notice);
			if (enabled)
				statement.setString(3, "true");
			else
				statement.setString(3, "false");
			statement.setString(4, notice);
			if (enabled)
				statement.setString(5, "true");
			else
				statement.setString(5, "false");
			statement.execute();
			statement.close();
		} catch (Exception e) {
			_log.error("Error could not store clan notice: ", e);
		} finally {
			try {
				con.close();
			} catch (Exception e) {
			}
		}

		_notice = notice;
		_noticeEnabled = enabled;
	}

	public void setNoticeEnabled(boolean enabled) {
		storeNotice(_notice, enabled);
	}

	public void setNotice(String notice) {
		storeNotice(notice, _noticeEnabled);
	}

	public boolean isNoticeEnabled() {
		return _noticeEnabled;
	}

	public String getNotice() {
		if (_notice == null)
			return "";
		return _notice;
	}

	private void restoreSkills() {
		Connection con = null;

		try {
			// Retrieve all skills of this L2PcInstance from the database
			con = L2DatabaseFactory.getInstance().getConnection();
			PreparedStatement statement = con.prepareStatement("SELECT skill_id,skill_level FROM clan_skills WHERE clan_id=?");
			statement.setLong(1, getClanId());

			ResultSet rset = statement.executeQuery();

			// Go though the recordset of this SQL query
			while (rset.next()) {
				int id = rset.getInt("skill_id");
				int level = rset.getInt("skill_level");
				// Create a L2Skill object for each record
				L2Skill skill = SkillTable.getInstance().getInfo(id, level);
				// Add the L2Skill object to the L2Clan _skills
				_skills.put(skill.getId(), skill);
			}

			rset.close();
			statement.close();
		} catch (Exception e) {
			_log.error("Error restoring clan skills.", e);
		} finally {
			try {
				con.close();
			} catch (Exception e) {
			}
		}
	}

	/** used to retrieve all skills */
	public final L2Skill[] getAllSkills() {
		if (_skills == null)
			return new L2Skill[0];

		return _skills.values().toArray(new L2Skill[_skills.values().size()]);
	}

	/** used to add a skill to skill list of this L2Clan */
	public L2Skill addSkill(L2Skill newSkill) {
		L2Skill oldSkill = null;

		if (newSkill != null) {
			// Replace oldSkill by newSkill or Add the newSkill
			oldSkill = _skills.put(newSkill.getId(), newSkill);
		}

		return oldSkill;
	}

	/** used to add a new skill to the list, send a packet to all online clan members, update their stats and store it in db*/
	public L2Skill addNewSkill(L2Skill newSkill) {
		L2Skill oldSkill = null;
		Connection con = null;

		if (newSkill != null) {

			// Replace oldSkill by newSkill or Add the newSkill
			oldSkill = _skills.put(newSkill.getId(), newSkill);

			try {
				con = L2DatabaseFactory.getInstance().getConnection();
				PreparedStatement statement;

				if (oldSkill != null) {
					statement = con.prepareStatement("UPDATE clan_skills SET skill_level=? WHERE skill_id=? AND clan_id=?");
					statement.setInt(1, newSkill.getLevel());
					statement.setInt(2, oldSkill.getId());
					statement.setLong(3, getClanId());
					statement.execute();
					statement.close();
				} else {
					statement = con.prepareStatement("INSERT INTO clan_skills (clan_id,skill_id,skill_level,skill_name) VALUES (?,?,?,?)");
					statement.setLong(1, getClanId());
					statement.setInt(2, newSkill.getId());
					statement.setInt(3, newSkill.getLevel());
					statement.setString(4, newSkill.getName());
					statement.execute();
					statement.close();
				}
			} catch (Exception e) {
//				_log.warning("Error could not store clan skills: " + e);
			} finally {
				try {
					con.close();
				} catch (Exception e) {
				}
			}

			for (L2ClanMember temp : _members.values()) {
				try {
//					if (temp.isOnline()) {
//						if (newSkill.getMinPledgeClass() <= temp.getPlayerInstance().getPledgeClass()) {
//							temp.getPlayerInstance().addSkill(newSkill, false); // Skill is not saved to player DB
//							temp.getPlayerInstance().sendPacket(new PledgeSkillListAdd(newSkill.getId(), newSkill.getLevel()));
//						}
//					}
				} catch (NullPointerException e) {
				}
			}
		}

		return oldSkill;
	}

	public void addSkillEffects() {
		for (L2Skill skill : _skills.values()) {
			for (L2ClanMember temp : _members.values()) {
				try {
//					if (temp.isOnline()) {
//						if (skill.getMinPledgeClass() <= temp.getPlayerInstance().getPledgeClass())
//							temp.getPlayerInstance().addSkill(skill, false); // Skill is not saved to player DB
//					}
				} catch (NullPointerException e) {
				}
			}
		}
	}

	public void addSkillEffects(FuzePcInstance cm) {
		if (cm == null)
			return;

		for (L2Skill skill : _skills.values()) {
			//TODO add skills according to members class( in ex. don't add Clan Agillity skill's effect to lower class then Baron)
//			if (skill.getMinPledgeClass() <= cm.getPledgeClass())
//				cm.addSkill(skill, false); // Skill is not saved to player DB
		}
	}

	/*
	 public void broadcastToOnlineAllyMembers(L2GameServerPacket packet)
	 {
	 if (getAllyId() == 0)
	 {
	 return;
	 }
	 for (L2Clan clan : _allyList.values())
	 {
	 clan.broadcastToOnlineMembers(packet);
	 }
	 }
	 */
	public void broadcastToOnlineAllyMembers(L2GameServerPacket packet) {
		if (getAllyId() == 0) {
			return;
		}
		for (L2Clan clan : ClanTable.getInstance().getClans()) {
			if (clan.getAllyId() == getAllyId()) {
				clan.broadcastToOnlineMembers(packet);
			}
		}
	}

	public void broadcastToOnlineMembers(L2GameServerPacket packet) {
		for (L2ClanMember member : _members.values()) {
			try {
				if (member.isOnline()) {
					FuzePcInstance mem = member.getPlayerInstance();
					if (mem != null && mem.getSwitchByChatCode(Say2.COMMUNITY_CHANNAL)) 
						mem.sendPacket(packet);
				}
					
			} catch (NullPointerException e) {
			}
		}
	}

	public void broadcastCSToOnlineMembers(CreatureSay packet, FuzePcInstance broadcaster) {
		for (L2ClanMember member : _members.values()) {
			try {
				if (member.isOnline() && !BlockList.isBlocked(member.getPlayerInstance(), broadcaster)) {
					FuzePcInstance mem = member.getPlayerInstance();
					if (mem != null && mem.getSwitchByChatCode(Say2.CLAN_CHANNAL))
						mem.sendPacket(packet);
				}
					
			} catch (NullPointerException e) {
			}
		}
	}

	public void broadcastToOtherOnlineMembers(L2GameServerPacket packet, FuzePcInstance player) {
		for (L2ClanMember member : _members.values()) {
			try {
				if (member.isOnline() && member.getPlayerInstance() != player)
					member.getPlayerInstance().sendPacket(packet);
			} catch (NullPointerException e) {
			}
		}
	}

	@Override
	public String toString() {
		return getName();
	}

	/**
	 * @return
	 */
	public boolean hasCrest() {
		return _hasCrest;
	}

	public boolean hasCrestLarge() {
		return _hasCrestLarge;
	}

	public void setHasCrest(boolean flag) {
		_hasCrest = flag;
	}

	public void setHasCrestLarge(boolean flag) {
		_hasCrestLarge = flag;
	}

	public ItemContainer getWarehouse() {
//		return _warehouse;
		return null;
	}

	public boolean isAtWarWith(long id) {
		if (_atWarWith != null && !_atWarWith.isEmpty())
			if (_atWarWith.contains(id))
				return true;
		return false;
	}

	public boolean isAtWarAttacker(long id) {
		if (_atWarAttackers != null && !_atWarAttackers.isEmpty())
			if (_atWarAttackers.contains(id))
				return true;
		return false;
	}

	public void setEnemyClan(L2Clan clan) {
		long id = clan.getClanId();
		_atWarWith.add(id);
	}

	public void setEnemyClan(Long clan) {
		_atWarWith.add(clan);
	}

	public void setAttackerClan(L2Clan clan) {
		long id = clan.getClanId();
		_atWarAttackers.add(id);
	}

	public void setAttackerClan(Long clan) {
		_atWarAttackers.add(clan);
	}

	public void deleteEnemyClan(L2Clan clan) {
		long id = clan.getClanId();
		_atWarWith.remove(id);
	}

	public void deleteAttackerClan(L2Clan clan) {
		long id = clan.getClanId();
		_atWarAttackers.remove(id);
	}

	public int getHiredGuards() {
		return _hiredGuards;
	}

	public void incrementHiredGuards() {
		_hiredGuards++;
	}

	public boolean isAtWar() {
		if (_atWarWith != null && !_atWarWith.isEmpty())
			return true;
		return false;
	}

	public List<Long> getWarList() {
		return _atWarWith;
	}

	public List<Long> getAttackerList() {
		return _atWarAttackers;
	}

	public void broadcastClanStatus() {
//		for (FuzePcInstance member : getOnlineMembers(0)) {
//			member.sendPacket(new PledgeShowMemberListDeleteAll());
//			member.sendPacket(new PledgeShowMemberListAll(this, member));
//		}
	}

	public void removeSkill(int id) {
		L2Skill deleteSkill = null;
		for (L2Skill sk : _skillList) {
			if (sk.getId() == id) {
				deleteSkill = sk;
				return;
			}
		}
		_skillList.remove(deleteSkill);
	}

	public void removeSkill(L2Skill deleteSkill) {
		_skillList.remove(deleteSkill);
	}

	/**
	 * @return
	 */
	public List<L2Skill> getSkills() {
		return _skillList;
	}

	public class SubPledge {
		private int _id;

		private String _subPledgeName;

		private int _leaderId;

		public SubPledge(int id, String name, int leaderId) {
			_id = id;
			_subPledgeName = name;
			_leaderId = leaderId;
		}

		public int getId() {
			return _id;
		}

		public String getName() {
			return _subPledgeName;
		}

		public int getLeaderId() {
			return _leaderId;
		}

		public void setLeaderId(int leaderId) {
			_leaderId = leaderId;
		}
	}

	public class RankPrivs {
		private int _rankId;

		private int _party;// TODO find out what this stuff means and implement it

		private int _rankPrivs;

		public RankPrivs(int rank, int party, int privs) {
			_rankId = rank;
			_party = party;
			_rankPrivs = privs;
		}

		public int getRank() {
			return _rankId;
		}

		public int getParty() {
			return _party;
		}

		public int getPrivs() {
			return _rankPrivs;
		}

		public void setPrivs(int privs) {
			_rankPrivs = privs;
		}
	}

	private void restoreSubPledges() {
		Connection con = null;

		try {
			// Retrieve all subpledges of this clan from the database
			con = L2DatabaseFactory.getInstance().getConnection();
			PreparedStatement statement = con.prepareStatement("SELECT sub_pledge_id,name,leader_id FROM clan_subpledges WHERE clan_id=?");
			statement.setLong(1, getClanId());
			ResultSet rset = statement.executeQuery();

			while (rset.next()) {
				int id = rset.getInt("sub_pledge_id");
				String name = rset.getString("name");
				int leaderId = rset.getInt("leader_id");
				// Create a SubPledge object for each record
				SubPledge pledge = new SubPledge(id, name, leaderId);
//				_subPledges.put(id, pledge);
			}

			rset.close();
			statement.close();
		} catch (Exception e) {
//			_log.warning("Could not restore clan sub-units: " + e);
		} finally {
			try {
				con.close();
			} catch (Exception e) {
			}
		}
	}

	/** used to retrieve subPledge by type */
	public final SubPledge getSubPledge(int pledgeType) {
		if (_subPledges == null)
			return null;

		return _subPledges.get(pledgeType);
	}

	/** used to retrieve subPledge by type */
	public final SubPledge getSubPledge(String pledgeName) {
		if (_subPledges == null)
			return null;

		for (SubPledge sp : _subPledges.values()) {
			if (sp.getName().equalsIgnoreCase(pledgeName)) {
				return sp;
			}
		}
		return null;
	}

	/** used to retrieve all subPledges */
	public final SubPledge[] getAllSubPledges() {
		if (_subPledges == null)
			return new SubPledge[0];

		return _subPledges.values().toArray(new SubPledge[_subPledges.values().size()]);
	}

	public SubPledge createSubPledge(FuzePcInstance player, int pledgeType, int leaderId, String subPledgeName) {
		SubPledge subPledge = null;
		pledgeType = getAvailablePledgeTypes(pledgeType);
		if (pledgeType == 0) {
			if (pledgeType == L2Clan.SUBUNIT_ACADEMY)
				player.sendPacket(new SystemMessage(SystemMessageId.CLAN_HAS_ALREADY_ESTABLISHED_A_CLAN_ACADEMY));
			else
				player.sendMessage("You can't create any more sub-units of this type");
			return null;
		}
		if (_leader.getObjectId() == leaderId) {
			player.sendMessage("Leader is not correct");
			return null;
		}

		// Royal Guard 5000 points per each
		// Order of Knights 10000 points per each
		if (pledgeType != -1 && ((getReputationScore() < 5000 && pledgeType < L2Clan.SUBUNIT_KNIGHT1) || (getReputationScore() < 10000 && pledgeType > L2Clan.SUBUNIT_ROYAL2))) {
			SystemMessage sp = new SystemMessage(SystemMessageId.THE_CLAN_REPUTATION_SCORE_IS_TOO_LOW);
			player.sendPacket(sp);
			return null;
		} else {
			Connection con = null;
			try {
				con = L2DatabaseFactory.getInstance().getConnection();
				PreparedStatement statement = con.prepareStatement("INSERT INTO clan_subpledges (clan_id,sub_pledge_id,name,leader_id) values (?,?,?,?)");
				statement.setLong(1, getClanId());
				statement.setInt(2, pledgeType);
				statement.setString(3, subPledgeName);
				if (pledgeType != -1)
					statement.setInt(4, leaderId);
				else
					statement.setInt(4, 0);
				statement.execute();
				statement.close();

				subPledge = new SubPledge(pledgeType, subPledgeName, leaderId);
//				_subPledges.put(pledgeType, subPledge);

//				if (pledgeType != -1) {
//					// Royal Guard 5000 points per each
//					// Order of Knights 10000 points per each
//					if (pledgeType < L2Clan.SUBUNIT_KNIGHT1)
//						setReputationScore(getReputationScore() - Config.ROYAL_GUARD_COST, true);
//					else
//						setReputationScore(getReputationScore() - Config.KNIGHT_UNIT_COST, true);
//					//TODO: clan lvl9 or more can reinforce knights cheaper if first knight unit already created, use Config.KNIGHT_REINFORCE_COST
//				}

				if (Config.DEBUG)
					_log.info("New sub_clan saved in db: " + getClanId() + "; " + pledgeType);
			} catch (Exception e) {
				_log.error("Error saving sub clan data.", e);
			} finally {
				try {
					con.close();
				} catch (Exception e) {
				}
			}
		}
//		broadcastToOnlineMembers(new PledgeShowInfoUpdate(_leader.getClan()));
//		broadcastToOnlineMembers(new PledgeReceiveSubPledgeCreated(subPledge, _leader.getClan()));
		return subPledge;
	}

	public int getAvailablePledgeTypes(int pledgeType) {
		if (_subPledges.get(pledgeType) != null) {
			//_log.warning("found sub-unit with id: "+pledgeType);
			switch (pledgeType) {
			case SUBUNIT_ACADEMY:
				return 0;
			case SUBUNIT_ROYAL1:
				pledgeType = getAvailablePledgeTypes(SUBUNIT_ROYAL2);
				break;
			case SUBUNIT_ROYAL2:
				return 0;
			case SUBUNIT_KNIGHT1:
				pledgeType = getAvailablePledgeTypes(SUBUNIT_KNIGHT2);
				break;
			case SUBUNIT_KNIGHT2:
				pledgeType = getAvailablePledgeTypes(SUBUNIT_KNIGHT3);
				break;
			case SUBUNIT_KNIGHT3:
				pledgeType = getAvailablePledgeTypes(SUBUNIT_KNIGHT4);
				break;
			case SUBUNIT_KNIGHT4:
				return 0;
			}
		}
		return pledgeType;
	}

	public void updateSubPledgeInDB(int pledgeType) {
		Connection con = null;
		try {
			con = L2DatabaseFactory.getInstance().getConnection();
			PreparedStatement statement = con.prepareStatement("UPDATE clan_subpledges SET leader_id=? WHERE clan_id=? AND sub_pledge_id=?");
			statement.setInt(1, getSubPledge(pledgeType).getLeaderId());
			statement.setLong(2, getClanId());
			statement.setInt(3, pledgeType);
			statement.execute();
			statement.close();
			if (Config.DEBUG)
				_log.info("New subpledge leader saved in db: " + getClanId());
		} catch (Exception e) {
			_log.error("Error saving new sub clan leader.", e);
		} finally {
			try {
				con.close();
			} catch (Exception e) {
			}
		}
	}

	private void restoreRankPrivs() {
		Connection con = null;

		try {
			// Retrieve all skills of this L2PcInstance from the database
			con = L2DatabaseFactory.getInstance().getConnection();
			PreparedStatement statement = con.prepareStatement("SELECT privs,rank,party FROM clan_privs WHERE clan_id=?");
			statement.setLong(1, getClanId());
			//_log.warning("clanPrivs restore for ClanId : "+getClanId());
			ResultSet rset = statement.executeQuery();

			// Go though the recordset of this SQL query
			while (rset.next()) {
				int rank = rset.getInt("rank");
				//int party = rset.getInt("party");
				int privileges = rset.getInt("privs");
				// Create a SubPledge object for each record
				if (rank == -1)
					continue;

				_privs.get(rank).setPrivs(privileges);
			}

			rset.close();
			statement.close();
		} catch (Exception e) {
			_log.error("Error restoring clan privs by rank.", e);
		} finally {
			try {
				con.close();
			} catch (Exception e) {
			}
		}
	}

	public void initializePrivs() {
		RankPrivs privs;
		for (int i = 1; i < 10; i++) {
			privs = new RankPrivs(i, 0, CP_NOTHING);
			_privs.put(i, privs);
		}

	}

	public int getRankPrivs(int rank) {
		if (_privs.get(rank) != null)
			return _privs.get(rank).getPrivs();
		else
			return CP_NOTHING;
	}

	public void setRankPrivs(int rank, int privs) {
		if (_privs.get(rank) != null) {
			_privs.get(rank).setPrivs(privs);

			Connection con = null;

			try {
				//_log.warning("requested store clan privs in db for rank: "+rank+", privs: "+privs);
				// Retrieve all skills of this L2PcInstance from the database
				con = L2DatabaseFactory.getInstance().getConnection();
				PreparedStatement statement = con.prepareStatement("INSERT INTO clan_privs (clan_id,rank,party,privs) VALUES (?,?,?,?) ON DUPLICATE KEY UPDATE privs = ?");
				statement.setLong(1, getClanId());
				statement.setInt(2, rank);
				statement.setInt(3, 0);
				statement.setInt(4, privs);
				statement.setInt(5, privs);

				statement.execute();
				statement.close();
			} catch (Exception e) {
				_log.error("Could not store clan privs for rank: ", e);
			} finally {
				try {
					con.close();
				} catch (Exception e) {
				}
			}
			for (L2ClanMember cm : getMembers()) {
				if (cm.isOnline())
					if (cm.getPowerGrade() == rank)
						if (cm.getPlayerInstance() != null) {
							cm.getPlayerInstance().setClanPrivileges(privs);
							cm.getPlayerInstance().sendPacket(new UserInfo(cm.getPlayerInstance()));
//							cm.getPlayerInstance().sendPacket(new ExBrExtraUserInfo(cm.getPlayerInstance()));
						}
			}
			broadcastClanStatus();
		} else {
			_privs.put(rank, new RankPrivs(rank, 0, privs));

			Connection con = null;

			try {
				//_log.warning("requested store clan new privs in db for rank: "+rank);
				// Retrieve all skills of this L2PcInstance from the database
				con = L2DatabaseFactory.getInstance().getConnection();
				PreparedStatement statement = con.prepareStatement("INSERT INTO clan_privs (clan_id,rank,party,privs) VALUES (?,?,?,?)");
				statement.setLong(1, getClanId());
				statement.setInt(2, rank);
				statement.setInt(3, 0);
				statement.setInt(4, privs);
				statement.execute();
				statement.close();
			} catch (Exception e) {
				_log.error("Could not create new rank and store clan privs for rank: ", e);
			} finally {
				try {
					con.close();
				} catch (Exception e) {
				}
			}
		}
	}

	/** used to retrieve all RankPrivs */
	public final RankPrivs[] getAllRankPrivs() {
		if (_privs == null)
			return new RankPrivs[0];

		return _privs.values().toArray(new RankPrivs[_privs.values().size()]);
	}

	public int getLeaderSubPledge(long leaderId) {
		int id = 0;
		for (SubPledge sp : _subPledges.values()) {
			if (sp.getLeaderId() == 0)
				continue;
			if (sp.getLeaderId() == leaderId)
				id = sp.getId();
		}
		return id;
	}

	public void setReputationScore(int value, boolean save) {
		if (_reputationScore >= 0 && value < 0) {
			broadcastToOnlineMembers(new SystemMessage(SystemMessageId.REPUTATION_POINTS_0_OR_LOWER_CLAN_SKILLS_DEACTIVATED));
			L2Skill[] skills = getAllSkills();
			for (L2ClanMember member : _members.values()) {
				if (member.isOnline() && member.getPlayerInstance() != null) {
					for (L2Skill sk : skills)
						member.getPlayerInstance().removeSkill(sk, false);
				}
			}
		} else if (_reputationScore < 0 && value >= 0) {
			broadcastToOnlineMembers(new SystemMessage(SystemMessageId.CLAN_SKILLS_WILL_BE_ACTIVATED_SINCE_REPUTATION_IS_0_OR_HIGHER));
			L2Skill[] skills = getAllSkills();
			for (L2ClanMember member : _members.values()) {
				if (member.isOnline() && member.getPlayerInstance() != null) {
//					for (L2Skill sk : skills) {
//						if (sk.getMinPledgeClass() <= member.getPlayerInstance().getPledgeClass())
//							member.getPlayerInstance().addSkill(sk, false);
//					}
				}
			}
		}

		_reputationScore = value;
		if (_reputationScore > 100000000)
			_reputationScore = 100000000;
		if (_reputationScore < -100000000)
			_reputationScore = -100000000;
//		broadcastToOnlineMembers(new PledgeShowInfoUpdate(this));
		if (save)
			updateClanInDB();
	}

	public int getReputationScore() {
		return _reputationScore;
	}

	public void setRank(int rank) {
		_rank = rank;
	}

	public int getRank() {
		return _rank;
	}

	public int getAuctionBiddedAt() {
		return _auctionBiddedAt;
	}

	public void setAuctionBiddedAt(int id, boolean storeInDb) {
		_auctionBiddedAt = id;

		if (storeInDb) {
			Connection con = null;
			try {
				con = L2DatabaseFactory.getInstance().getConnection();
				PreparedStatement statement = con.prepareStatement("UPDATE clan_data SET auction_bid_at=? WHERE clan_id=?");
				statement.setInt(1, id);
				statement.setLong(2, getClanId());
				statement.execute();
				statement.close();
			} catch (Exception e) {
				_log.error("Could not store auction for clan: ", e);
			} finally {
				try {
					con.close();
				} catch (Exception e) {
				}
			}
		}
	}

	/**
	 * Checks if activeChar and target meet various conditions to join a clan
	 *
	 * @param activeChar
	 * @param target
	 * @param pledgeType
	 * @return
	 */
	public boolean checkClanJoinCondition(FuzePcInstance activeChar, FuzePcInstance target, int pledgeType) {
		if (activeChar == null) {
			return false;
		}
		if ((activeChar.getClanPrivileges() & L2Clan.CP_CL_JOIN_CLAN) != L2Clan.CP_CL_JOIN_CLAN) {
			activeChar.sendPacket(new SystemMessage(SystemMessageId.YOU_ARE_NOT_AUTHORIZED_TO_DO_THAT));
			return false;
		}
		if (target == null) {
			activeChar.sendPacket(new SystemMessage(SystemMessageId.YOU_HAVE_INVITED_THE_WRONG_TARGET));
			return false;
		}
		if (activeChar.getObjectId() == target.getObjectId()) {
			activeChar.sendPacket(new SystemMessage(SystemMessageId.CANNOT_INVITE_YOURSELF));
			return false;
		}
		if (getCharPenaltyExpiryTime() > System.currentTimeMillis()) {
			SystemMessage sm = new SystemMessage(SystemMessageId.YOU_MUST_WAIT_BEFORE_ACCEPTING_A_NEW_MEMBER);
			sm.addString(target.getName());
			activeChar.sendPacket(sm);
			sm = null;
			return false;
		}
		if (target.getClanId() != 0) {
			SystemMessage sm = new SystemMessage(SystemMessageId.S1_WORKING_WITH_ANOTHER_CLAN);
			sm.addString(target.getName());
			activeChar.sendPacket(sm);
			sm = null;
			return false;
		}
		if (target.getClanJoinExpiryTime() > System.currentTimeMillis()) {
			SystemMessage sm = new SystemMessage(SystemMessageId.C1_MUST_WAIT_BEFORE_JOINING_ANOTHER_CLAN);
			sm.addString(target.getName());
			activeChar.sendPacket(sm);
			sm = null;
			return false;
		}
		if ((target.getLevel() > 40) && pledgeType == -1) {
			SystemMessage sm = new SystemMessage(SystemMessageId.S1_DOESNOT_MEET_REQUIREMENTS_TO_JOIN_ACADEMY);
			sm.addString(target.getName());
			activeChar.sendPacket(sm);
			sm = null;
			activeChar.sendPacket(new SystemMessage(SystemMessageId.ACADEMY_REQUIREMENTS));
			return false;
		}
		if (getSubPledgeMembersCount(pledgeType) >= getMaxNrOfMembers(pledgeType)) {
			if (pledgeType == 0) {
				SystemMessage sm = new SystemMessage(SystemMessageId.S1_CLAN_IS_FULL);
				sm.addString(getName());
				activeChar.sendPacket(sm);
				sm = null;
			} else {
				activeChar.sendPacket(new SystemMessage(SystemMessageId.SUBCLAN_IS_FULL));
			}
			return false;
		}
		return true;
	}

	/**
	 * Checks if activeChar and target meet various conditions to join a clan
	 *
	 * @param activeChar
	 * @param target
	 * @return
	 */
	public boolean checkAllyJoinCondition(FuzePcInstance activeChar, FuzePcInstance target) {
		if (activeChar == null) {
			return false;
		}
//		if (activeChar.getAllyId() == 0 || !activeChar.isClanLeader() || activeChar.getClanId() != activeChar.getAllyId()) {
//			activeChar.sendPacket(new SystemMessage(SystemMessageId.FEATURE_ONLY_FOR_ALLIANCE_LEADER));
//			return false;
//		}
		L2Clan leaderClan = activeChar.getClan();
		if (leaderClan.getAllyPenaltyExpiryTime() > System.currentTimeMillis()) {
			if (leaderClan.getAllyPenaltyType() == PENALTY_TYPE_DISMISS_CLAN) {
				activeChar.sendPacket(new SystemMessage(SystemMessageId.CANT_INVITE_CLAN_WITHIN_1_DAY));
				return false;
			}
		}
		if (target == null) {
			activeChar.sendPacket(new SystemMessage(SystemMessageId.YOU_HAVE_INVITED_THE_WRONG_TARGET));
			return false;
		}
		if (activeChar.getObjectId() == target.getObjectId()) {
			activeChar.sendPacket(new SystemMessage(SystemMessageId.CANNOT_INVITE_YOURSELF));
			return false;
		}
		if (target.getClan() == null) {
			activeChar.sendPacket(new SystemMessage(SystemMessageId.TARGET_MUST_BE_IN_CLAN));
			return false;
		}
		if (!target.isClanLeader()) {
			SystemMessage sm = new SystemMessage(SystemMessageId.S1_IS_NOT_A_CLAN_LEADER);
			sm.addString(target.getName());
			activeChar.sendPacket(sm);
			sm = null;
			return false;
		}
		L2Clan targetClan = target.getClan();
//		if (target.getAllyId() != 0) {
//			SystemMessage sm = new SystemMessage(SystemMessageId.S1_CLAN_ALREADY_MEMBER_OF_S2_ALLIANCE);
//			sm.addString(targetClan.getName());
//			sm.addString(targetClan.getAllyName());
//			activeChar.sendPacket(sm);
//			sm = null;
//			return false;
//		}
		if (targetClan.getAllyPenaltyExpiryTime() > System.currentTimeMillis()) {
			if (targetClan.getAllyPenaltyType() == PENALTY_TYPE_CLAN_LEAVED) {
				SystemMessage sm = new SystemMessage(SystemMessageId.S1_CANT_ENTER_ALLIANCE_WITHIN_1_DAY);
				sm.addString(target.getClan().getName());
				sm.addString(target.getClan().getAllyName());
				activeChar.sendPacket(sm);
				sm = null;
				return false;
			}
			if (targetClan.getAllyPenaltyType() == PENALTY_TYPE_CLAN_DISMISSED) {
				activeChar.sendPacket(new SystemMessage(SystemMessageId.CANT_ENTER_ALLIANCE_WITHIN_1_DAY));
				return false;
			}
		}
		if (activeChar.isInsideZone(L2Character.ZONE_SIEGE) && target.isInsideZone(L2Character.ZONE_SIEGE)) {
			activeChar.sendPacket(new SystemMessage(SystemMessageId.OPPOSING_CLAN_IS_PARTICIPATING_IN_SIEGE));
			return false;
		}
		if (leaderClan.isAtWarWith(targetClan.getClanId())) {
			activeChar.sendPacket(new SystemMessage(SystemMessageId.MAY_NOT_ALLY_CLAN_BATTLE));
			return false;
		}

		int numOfClansInAlly = 0;
//		for (L2Clan clan : ClanTable.getInstance().getClans()) {
//			if (clan.getAllyId() == activeChar.getAllyId()) {
//				++numOfClansInAlly;
//			}
//		}
		if (numOfClansInAlly >= Config.ALT_MAX_NUM_OF_CLANS_IN_ALLY) {
			activeChar.sendPacket(new SystemMessage(SystemMessageId.YOU_HAVE_EXCEEDED_THE_LIMIT));
			return false;
		}

		return true;
	}

	public long getAllyPenaltyExpiryTime() {
		return _allyPenaltyExpiryTime;
	}

	public int getAllyPenaltyType() {
		return _allyPenaltyType;
	}

	public void setAllyPenaltyExpiryTime(long expiryTime, int penaltyType) {
		_allyPenaltyExpiryTime = expiryTime;
		_allyPenaltyType = penaltyType;
	}

	public long getCharPenaltyExpiryTime() {
		return _charPenaltyExpiryTime;
	}

	public void setCharPenaltyExpiryTime(long time) {
		_charPenaltyExpiryTime = time;
	}

	public long getDissolvingExpiryTime() {
		return _dissolvingExpiryTime;
	}

	public void setDissolvingExpiryTime(long time) {
		_dissolvingExpiryTime = time;
	}

	public void createAlly(FuzePcInstance player, String allyName) {
		if (null == player)
			return;

//		if (Config.DEBUG)
//			_log.fine(player.getObjectId() + "(" + player.getName() + ") requested ally creation from ");

		if (!player.isClanLeader()) {
			player.sendPacket(new SystemMessage(SystemMessageId.ONLY_CLAN_LEADER_CREATE_ALLIANCE));
			return;
		}
		if (getAllyId() != 0) {
			player.sendPacket(new SystemMessage(SystemMessageId.ALREADY_JOINED_ALLIANCE));
			return;
		}
		if (getLevel() < 5) {
			player.sendPacket(new SystemMessage(SystemMessageId.TO_CREATE_AN_ALLY_YOU_CLAN_MUST_BE_LEVEL_5_OR_HIGHER));
			return;
		}
		if (getAllyPenaltyExpiryTime() > System.currentTimeMillis()) {
			if (getAllyPenaltyType() == L2Clan.PENALTY_TYPE_DISSOLVE_ALLY) {
				player.sendPacket(new SystemMessage(SystemMessageId.CANT_CREATE_ALLIANCE_10_DAYS_DISOLUTION));
				return;
			}
		}
		if (getDissolvingExpiryTime() > System.currentTimeMillis()) {
			player.sendPacket(new SystemMessage(SystemMessageId.YOU_MAY_NOT_CREATE_ALLY_WHILE_DISSOLVING));
			return;
		}
		if (!Util.isAlphaNumeric(allyName)) {
			player.sendPacket(new SystemMessage(SystemMessageId.INCORRECT_ALLIANCE_NAME));
			return;
		}
		if (allyName.length() > 16 || allyName.length() < 2) {
			player.sendPacket(new SystemMessage(SystemMessageId.INCORRECT_ALLIANCE_NAME_LENGTH));
			return;
		}
		if (ClanTable.getInstance().isAllyExists(allyName)) {
			player.sendPacket(new SystemMessage(SystemMessageId.ALLIANCE_ALREADY_EXISTS));
			return;
		}

		setAllyId(getClanId());
		setAllyName(allyName.trim());
		setAllyPenaltyExpiryTime(0, 0);
		updateClanInDB();

		player.sendPacket(new UserInfo(player));
//		player.sendPacket(new ExBrExtraUserInfo(player));

		//TODO: Need correct message id
		player.sendMessage("Alliance " + allyName + " has been created.");
	}

	public void dissolveAlly(FuzePcInstance player) {
		if (getAllyId() == 0) {
			player.sendPacket(new SystemMessage(SystemMessageId.NO_CURRENT_ALLIANCES));
			return;
		}
		if (!player.isClanLeader() || getClanId() != getAllyId()) {
			player.sendPacket(new SystemMessage(SystemMessageId.FEATURE_ONLY_FOR_ALLIANCE_LEADER));
			return;
		}
		if (player.isInsideZone(L2Character.ZONE_SIEGE)) {
			player.sendPacket(new SystemMessage(SystemMessageId.CANNOT_DISSOLVE_ALLY_WHILE_IN_SIEGE));
			return;
		}

		broadcastToOnlineAllyMembers(new SystemMessage(SystemMessageId.ALLIANCE_DISOLVED));

		long currentTime = System.currentTimeMillis();
		for (L2Clan clan : ClanTable.getInstance().getClans()) {
			if (clan.getAllyId() == getAllyId() && clan.getClanId() != getClanId()) {
				clan.setAllyId(0);
				clan.setAllyName(null);
				clan.setAllyPenaltyExpiryTime(0, 0);
				clan.updateClanInDB();
			}
		}

		setAllyId(0);
		setAllyName(null);
		setAllyPenaltyExpiryTime(currentTime + Config.ALT_CREATE_ALLY_DAYS_WHEN_DISSOLVED * 86400000L, L2Clan.PENALTY_TYPE_DISSOLVE_ALLY); //24*60*60*1000 = 86400000
		updateClanInDB();

		// The clan leader should take the XP penalty of a full death.
//		player.deathPenalty(false, false, false);
	}

	public boolean levelUpClan(FuzePcInstance player) {
		if (!player.isClanLeader()) {
			player.sendPacket(new SystemMessage(SystemMessageId.YOU_ARE_NOT_AUTHORIZED_TO_DO_THAT));
			return false;
		}
		if (System.currentTimeMillis() < getDissolvingExpiryTime()) {
			player.sendPacket(new SystemMessage(SystemMessageId.CANNOT_RISE_LEVEL_WHILE_DISSOLUTION_IN_PROGRESS));
			return false;
		}

		boolean increaseClanLevel = false;

		switch (getLevel()) {
		case 0: {
			// Upgrade to 1
			if (player.getMoneySilver() >= 650000) {
				if (player.reduceMoneySilver("ClanLvl", 650000, player.getTarget(), true)) {
					SystemMessage sp = new SystemMessage(SystemMessageId.SP_DECREASED_S1);
					sp.addNumber(20000);
					player.sendPacket(sp);
					sp = null;
					increaseClanLevel = true;
				}
			}
			break;
		}
		case 1: {
			// Upgrade to 2
			if (player.getMoneySilver() >= 2500000) {
				if (player.reduceMoneySilver("ClanLvl", 2500000, player.getTarget(), true)) {
					SystemMessage sp = new SystemMessage(SystemMessageId.SP_DECREASED_S1);
					sp.addNumber(100000);
					player.sendPacket(sp);
					sp = null;
					increaseClanLevel = true;
				}
			}
			break;
		}
		case 2: {
			// Upgrade to 3
			if (player.getInventory().getItemByItemId(1419) != null) {
				// itemId 1419 == Blood Mark
				if (player.destroyItemByItemId("ClanLvl", 1419, 1, player.getTarget(), false)) {
					SystemMessage sp = new SystemMessage(SystemMessageId.SP_DECREASED_S1);
					sp.addNumber(350000);
					player.sendPacket(sp);
					sp = null;
					SystemMessage sm = new SystemMessage(SystemMessageId.S2_S1_DISAPPEARED);
					sm.addItemName(1419);
					sm.addItemNumber(1);
					player.sendPacket(sm);
					sm = null;
					increaseClanLevel = true;
				}
			}
			break;
		}
		case 3: {
			// Upgrade to 4
			if (player.getInventory().getItemByItemId(3874) != null) {
				// itemId 3874 == Alliance Manifesto
				if (player.destroyItemByItemId("ClanLvl", 3874, 1, player.getTarget(), false)) {
					SystemMessage sp = new SystemMessage(SystemMessageId.SP_DECREASED_S1);
					sp.addNumber(1000000);
					player.sendPacket(sp);
					sp = null;
					SystemMessage sm = new SystemMessage(SystemMessageId.S2_S1_DISAPPEARED);
					sm.addItemName(3874);
					sm.addItemNumber(1);
					player.sendPacket(sm);
					sm = null;
					increaseClanLevel = true;
				}
			}
			break;
		}
		case 4: {
			// Upgrade to 5
			if (player.getInventory().getItemByItemId(3870) != null) {
				// itemId 3870 == Seal of Aspiration
				if (player.destroyItemByItemId("ClanLvl", 3870, 1, player.getTarget(), false)) {
					SystemMessage sp = new SystemMessage(SystemMessageId.SP_DECREASED_S1);
					sp.addNumber(2500000);
					player.sendPacket(sp);
					sp = null;
					SystemMessage sm = new SystemMessage(SystemMessageId.S2_S1_DISAPPEARED);
					sm.addItemName(3870);
					sm.addItemNumber(1);
					player.sendPacket(sm);
					sm = null;
					increaseClanLevel = true;
				}
			}
			break;
		}
		case 5:
			// Upgrade to 6
//			if (getReputationScore() >= Config.CLAN_LEVEL_6_COST && getMembersCount() >= Config.CLAN_LEVEL_6_REQUIREMENT) {
//				setReputationScore(getReputationScore() - Config.CLAN_LEVEL_6_COST, true);
//				SystemMessage cr = new SystemMessage(SystemMessageId.S1_DEDUCTED_FROM_CLAN_REP);
//				cr.addNumber(Config.CLAN_LEVEL_6_COST);
//				player.sendPacket(cr);
//				cr = null;
//				increaseClanLevel = true;
//			}
			break;

		case 6:
			// Upgrade to 7
//			if (getReputationScore() >= Config.CLAN_LEVEL_7_COST && getMembersCount() >= Config.CLAN_LEVEL_7_REQUIREMENT) {
//				setReputationScore(getReputationScore() - Config.CLAN_LEVEL_7_COST, true);
//				SystemMessage cr = new SystemMessage(SystemMessageId.S1_DEDUCTED_FROM_CLAN_REP);
//				cr.addNumber(Config.CLAN_LEVEL_7_COST);
//				player.sendPacket(cr);
//				cr = null;
//				increaseClanLevel = true;
//			}
			break;
		case 7:
			// Upgrade to 8
//			if (getReputationScore() >= Config.CLAN_LEVEL_8_COST && getMembersCount() >= Config.CLAN_LEVEL_8_REQUIREMENT) {
//				setReputationScore(getReputationScore() - Config.CLAN_LEVEL_8_COST, true);
//				SystemMessage cr = new SystemMessage(SystemMessageId.S1_DEDUCTED_FROM_CLAN_REP);
//				cr.addNumber(Config.CLAN_LEVEL_8_COST);
//				player.sendPacket(cr);
//				cr = null;
//				increaseClanLevel = true;
//			}
			break;
		case 8:
			// Upgrade to 9
//			if (getReputationScore() >= Config.CLAN_LEVEL_9_COST && player.getInventory().getItemByItemId(9910) != null && getMembersCount() >= Config.CLAN_LEVEL_9_REQUIREMENT) {
//				// itemId 9910 == Blood Oath
//				if (player.destroyItemByItemId("ClanLvl", 9910, 150, player.getTarget(), false)) {
//					setReputationScore(getReputationScore() - Config.CLAN_LEVEL_9_COST, true);
//					SystemMessage cr = new SystemMessage(SystemMessageId.S1_DEDUCTED_FROM_CLAN_REP);
//					cr.addNumber(Config.CLAN_LEVEL_9_COST);
//					player.sendPacket(cr);
//					cr = null;
//					SystemMessage sm = new SystemMessage(SystemMessageId.S2_S1_DISAPPEARED);
//					sm.addItemName(9910);
//					sm.addItemNumber(150);
//					player.sendPacket(sm);
//					increaseClanLevel = true;
//				}
//			}
			break;
		case 9:
			// Upgrade to 10
//			if (getReputationScore() >= Config.CLAN_LEVEL_10_COST && player.getInventory().getItemByItemId(9911) != null && getMembersCount() >= Config.CLAN_LEVEL_10_REQUIREMENT) {
//				// itemId 9911 == Blood Alliance
//				if (player.destroyItemByItemId("ClanLvl", 9911, 5, player.getTarget(), false)) {
//					setReputationScore(getReputationScore() - Config.CLAN_LEVEL_10_COST, true);
//					SystemMessage cr = new SystemMessage(SystemMessageId.S1_DEDUCTED_FROM_CLAN_REP);
//					cr.addNumber(Config.CLAN_LEVEL_10_COST);
//					player.sendPacket(cr);
//					cr = null;
//					SystemMessage sm = new SystemMessage(SystemMessageId.S2_S1_DISAPPEARED);
//					sm.addItemName(9911);
//					sm.addItemNumber(5);
//					player.sendPacket(sm);
//					increaseClanLevel = true;
//				}
//			}
			break;
		default:
			return false;
		}

		if (!increaseClanLevel) {
			SystemMessage sm = new SystemMessage(SystemMessageId.FAILED_TO_INCREASE_CLAN_LEVEL);
			player.sendPacket(sm);
			return false;
		}

		ItemList il = new ItemList(player, false);
		player.sendPacket(il);

		changeLevel(getLevel() + 1);
		return true;
	}

	public void changeLevel(int level) {
		Connection con = null;
		try {
			con = L2DatabaseFactory.getInstance().getConnection();
			PreparedStatement statement = con.prepareStatement("UPDATE clan_data SET clan_level = ? WHERE clan_id = ?");
			statement.setInt(1, level);
			statement.setLong(2, getClanId());
			statement.execute();
			statement.close();
		} catch (Exception e) {
//			_log.warning("could not increase clan level:" + e);
		} finally {
			try {
				con.close();
			} catch (Exception e) {
			}
		}

		setLevel(level);

		if (getLeader().isOnline()) {
			FuzePcInstance leader = getLeader().getPlayerInstance();
//			if (4 < level) {
//				SiegeManager.getInstance().addSiegeSkills(leader);
//			} else if (5 > level) {
//				SiegeManager.getInstance().removeSiegeSkills(leader);
//			}
//			if (4 < level) {
//				leader.sendPacket(new SystemMessage(SystemMessageId.CLAN_CAN_ACCUMULATE_CLAN_REPUTATION_POINTS));
//			}
		}

		// notify all the members about it
		broadcastToOnlineMembers(new SystemMessage(SystemMessageId.CLAN_LEVEL_INCREASED));
//		broadcastToOnlineMembers(new PledgeShowInfoUpdate(this));
		/*
		 * Micht :
		 * 	- use PledgeShowInfoUpdate instead of PledgeStatusChanged
		 * 		to update clan level ingame
		 * 	- remove broadcastClanStatus() to avoid members duplication
		 */
		//clan.broadcastToOnlineMembers(new PledgeStatusChanged(clan));
		//clan.broadcastClanStatus();
	}
}
